package com.sansi.pencilbook.mapper;

import com.sansi.pencilbook.entity.UserAndAddress;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.sql.SQLException;
import java.util.List;

/**
 * 功能说明:
 *
 * @author lsy13
 */
@Mapper
public interface UserAndAddressMapper {

    @Select("select address_id, user.user_account, address, phone from " +
            "shipping_address left join user on user.user_id = shipping_address.user_id " +
            "where store_id=0")
    public List<UserAndAddress> findAll() throws SQLException;

}
